Spreadsheet Generation from Rule-Based Specifications

Experimental studies have pointed out that operational spreadsheets contain a lot of errors In this paper we propose to use a multidimensional rule based data manipulation language to specify spreadsheets This language allows formal declarative de nition of spreadsheet tabular data treatments The main contribution of this paper is to show that from textual rule based speci cations we can generate the corresponding spreadsheet This generation of a spreadsheet from its logical de nition is a promising way to reduce encoding errors The technique presented has been implemented in a crude running prototype